2014-07-01 - 13449 - Spec - Dropship Exception Report #CrystalReportDevelopment
SPECIFICATION
13449 - Dropship Exception Report
Purpose
Create a new report OSA171 that displays the details of orders which have a dropship plant(9-series) with item category TAN.
Admin Info
Purpose
|
Dropship Exception Report OSA171
|
Requested By
|
Daniel Brennan
|
Spec Created By
|
Praveen Guntuka
|
Spec Created Date
|
07/01/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
OSA171 Crystal Report OSA171 &
BEX Query ZMP_OOCON_Q020
|
Document Status
|
Complete
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
04
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
16
|
4
|
Unit test in DEV
|
08
|
5
|
Unit test in QUA
|
00
|
6
|
Other activity
|
08
|
|
TOTAL
|
40
|
References
Prior Tickets
None
Documents
FSDR - Dropship Exception Report.docx
Spec Changes
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Add Fiscal Year and Fiscal Period to BEx query
|
Daniel Brennan
|
07-02-2014
|
To remove Repository functions from the report
|
Mail form Daniel Brennan on 07/31/2014:
Praveen,
I reviewed the report from BI-Dev with the business, and they are pleased with it. Can you please update the name to “Dropship Exception Report”? Also, I’m told by Ashwin that the source has been moved to production, so can you please map the report to that source and re-run it so I can perform final validations?
Thanks,
Dan
Functional Requirement
Purpose/WHY:
NEC requires a new report which displays the details of orders which have a dropship plant(9-series) with item category TAN.
In Scope:
Report should show Open Orders with a dropship plant(9- Series) and Item Category TAN only.
Out of Scope:
No need to display the open orders that do not fall under the above specified restrictions.
Solution Summary
1. Need to create new formulas for grouping and need to include them in report grouping order.
2. Need to suppress the respective groups.
3. Need to change the existing formulas.
4. Need to remove repository functions from the report.
Solution for issue on 07/31/2014 :
1. Need to Point the report to Production query.
2. Need to rename the report to "Dropship Exception Report".
3. Need to run the report in the BO Development server.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
1. Need to create new formulas for grouping level 1 for Region and level 2 for Sales Organization.
2. Need to create the new groups based on Grouping formula 1 and formula 2.
3. Need to suppress the respective groups in the report.
4. Need to change the existing formulas to show the correct values at respective grouping level.
5. Need to check & follow NEC standards while developing the report.
6. Need to remove repository functions from the report and place the BEx query fields.
7. Need to add 0FISCPER3 and 0FISCYEAR fields to BEx query.
Solution for 07/31/2014:
1. Need to Point the report to Production query.
2. Need to rename the report to "Dropship Exception Report".
3. Need to run the report in the BO Development server.
Issues
None